Learn how to control referential integrity from parent table for tables that reside in different SQL Server databases on the same server.
Learn how to identify the most current record from a historical dataset for a Power BI report in this step-by-step guide.
Learn how to use the Event Grid Topic resource in Azure to manage events between different instances of Azure Data Factory (ADF) or Synapse Analytics.
In this article we walk through the steps to install SQL Server Integration Services using SQL Server 2019.
Learn how to use SQLCMD to backup all of your SQL Server databases and also how to schedule execution of the backups using Windows Task Scheduler.
Did you know you can include a SELECT statement within another SELECT statement? When a SELECT statement is embedded within another statement it is known as a subquery. There are two types of subqueries: basic subquery and correlated subquery. In this article I will be discussing both types of subqueries and will be providing examples …
The post Using a Subquery in a SELECT statement appeared first on Simple Talk.
Learn about different ways you can use a CASE statement in the WHERE clause for a T-SQL statement with these several examples.
This article includes FAQs and links to questions, books, and training material to prepare and pass the DP-500 exam for Microsoft Azure and Power BI.
Learn how to automatically refresh cached web page data from a database based on data updates in either Oracle or SQL Server.
When moving to the cloud, security is critical and this article reviews things to consider when using Google Cloud services.
This article discusses using T-SQL to access metadata for SQL Server tables and how to query sys.tables, sys.columns, sys.system_columns, and sys.all_columns.
This article explains what Snowflake data warehouse is and how it is different from other traditional data warehouses. This article will cover how to create virtual warehouses and different types of tables, how to handle semi-structured data, how to profile queries, and the benefits of clustering keys. Practical demonstrations of the concepts explained will be …
The post Snowflake: A Cloud Warehouse Solution for Analytics appeared first on Simple Talk.
In this tutorial, we look at what a SQL Server columnstore index is, when you would use one, and the option to order a columnstore index on one or more columns.
We must have felt the pain when you have applied multiple patches and each time you have to give Y to the prompt in opatch. There is a solution available to this problem How to run Opatch in a non-interactive form We can run the opatch apply, napply, rollback and nrollback commands in non-interactive mode […]
The post How to run Opatch in non interactive form appeared first on Techgoeasy.
In this article, we explore three separate ways to join data in Python using pandas merge, pandas join, and pandasql library.
In this tip, we explore two behaviors for the DAX RANKX function that can lead to incorrect results and discuss workarounds and fixes.
In this article, learn how to set up and use Microsoft Data Gateway to connect data sources from various locations such as cloud or on-premises.
Learn about the SQL ROUND function and how it works to round numbers up or down or to truncate values at a specific location.
In this article, we look at a sample use case of how you can create SQLCMD batch files that can be interactive and reused in different SQL Server environments.
Learn about Aqua Data Studio which is a feature-rich management tool and IDE for over 40 database platforms such as SQL Server, Oracle, MySQL, Snowflake, and many more.
In this tutorial, learn how to build a comprehensive pivot table in Excel using data from a SQL Server database.
By developing a strong business case, building key relationships, using budgeting and forecasting tools, and providing training and support, tech leaders can effectively sell the benefits of the cloud and influence change.